﻿using System;
using System.Collections.Generic;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

namespace SRM
{
    public partial class ApplicationForm : System.Web.UI.Page
    {
        System.Data.DataSet ds = new System.Data.DataSet("Page_DataSet");

        protected void Page_Load(object sender, EventArgs e)
        {
            System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(
                System.Configuration.ConfigurationManager.ConnectionStrings["SRM"].ConnectionString);
            System.Data.SqlClient.SqlCommand cmd = conn.CreateCommand();
            cmd.CommandText = "SELECT * FROM SRM_ApplicantFamilyMembers_Tbl WHERE ApplicantKey = 1557";
            System.Data.SqlClient.SqlDataAdapter da = new System.Data.SqlClient.SqlDataAdapter(cmd);

            da.Fill(ds, "FamilyParticulars");

            cmd.CommandText = "SELECT * FROM SRM_Code WHERE CodeType LIKE 'REL' AND IsSAPCode = 1";
            da.Fill(ds, "Relationship");

            FamilyParticularsRadGrid.DataSource = ds.Tables["FamilyParticulars"];
            //FamilyParticularsRadGrid.DataBind();
            
        }

        protected void FamilyParticularsRadGrid_EditCommand(object source, Telerik.Web.UI.GridCommandEventArgs e)
        {
            System.Diagnostics.Debugger.Break();
        }


    }
}